{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CONTOH 1","CONTOH 2","CONTOH VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CONTOH 1","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DAFTAR",11006,{"$f":"INDEX($C$7:$C$21,MATCH(C2,$B$7:$B$21,0))","v":"Gordon Rutten"}]
[]
[]
[]
[null,"TARGET","NAMA","STATUS",null,"HELPER"]
[null,11001,"Alyson Stakoe",1,null,{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,$B$7:$B$21,ROW(A1)),\"\")","v":11001}]
[null,11002,"Benito Conger",1,null,11002]
[null,11003,"Charla Charvet",0,null,11004]
[null,11004,"Cletus Kapper",1,null,11005]
[null,11005,"Eloisa Mcgillivray",1,null,11006]
[null,11006,"Gordon Rutten",1,null,11007]
[null,11007,"Jeffrey Ronco",1,null,11010]
[null,11008,"Jewell Graham",0,null,11012]
[null,11009,"Leana Bunker",0,null,11015]
[null,11010,"Maritza Malek",1,null,""]
[null,11011,"Mui Leimberger",0,null,""]
[null,11012,"Rosie Wakely",1,null,""]
[null,11013,"Tenisha Purdin",0,null,""]
[null,11014,"Veronika Bassolino",0,null,""]
[null,11015,"Yessenia Valer",1,null,""]

{"sheet":"CONTOH 2","index":1,"n_rows":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"DAFTAR ID TERFILTER","115027041"]
[]
[]
[null,"IDX","ID","NAMA","STATUS","HLP.IDX","HLP.ID"]
[null,1,"112029420","Adelaide Conary","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A1)),\"\")","v":2},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114035180"}]
[null,2,"114035180","Alyson Stakoe","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A2)),\"\")","v":4},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112047853"}]
[null,3,"115023769","Amiee Rabb","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A3)),\"\")","v":5},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114033924"}]
[null,4,"112047853","Ann Hoeschen","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A4)),\"\")","v":6},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113029988"}]
[null,5,"114033924","Aron Fyler","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A5)),\"\")","v":7},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114022106"}]
[null,6,"113029988","Azalee Gokey","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A6)),\"\")","v":10},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"115047224"}]
[null,7,"114022106","Benito Conger","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A7)),\"\")","v":12},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113037446"}]
[null,8,"113021301","Billie Kaler","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A8)),\"\")","v":13},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"115022389"}]
[null,9,"114043545","Buddy Tavano","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A9)),\"\")","v":15},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113042398"}]
[null,10,"115047224","Carmina Archey","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A10)),\"\")","v":18},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114037341"}]
[null,11,"115029643","Chan Demario","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A11)),\"\")","v":19},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113024180"}]
[null,12,"113037446","Charla Charvet","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A12)),\"\")","v":21},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113048806"}]
[null,13,"115022389","Cherri Hortillosa","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A13)),\"\")","v":23},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112045949"}]
[null,14,"112043266","Claudette Carraher","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A14)),\"\")","v":26},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113048733"}]
[null,15,"113042398","Cletus Kapper","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A15)),\"\")","v":27},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"115049967"}]
[null,16,"113034590","Corina Arollo","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A16)),\"\")","v":30},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"115031866"}]
[null,17,"113028118","Curtis Weglarz","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A17)),\"\")","v":33},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113033819"}]
[null,18,"114037341","Cyrstal Stange","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A18)),\"\")","v":34},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113029185"}]
[null,19,"113024180","David Tardy","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A19)),\"\")","v":35},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112033801"}]
[null,20,"114044394","Denisha Bulland","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A20)),\"\")","v":36},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113049615"}]
[null,21,"113048806","Eloisa Mcgillivray","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A21)),\"\")","v":41},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112021197"}]
[null,22,"113039298","Emmie Donald","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A22)),\"\")","v":43},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112044738"}]
[null,23,"112045949","Enoch Arrollo","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A23)),\"\")","v":46},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114022488"}]
[null,24,"114025058","Ferne Kerth","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A24)),\"\")","v":47},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112048864"}]
[null,25,"113045592","Garland Splatt","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A25)),\"\")","v":48},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113040205"}]
[null,26,"113048733","Gloria Holyfield","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A26)),\"\")","v":53},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114027099"}]
[null,27,"115049967","Gordon Rutten","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A27)),\"\")","v":54},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"115038203"}]
[null,28,"113025955","Graig Kirksey","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A28)),\"\")","v":57},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112048545"}]
[null,29,"113041902","Isidra Danes","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A29)),\"\")","v":58},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114033521"}]
[null,30,"115031866","Jacinta Minrod","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A30)),\"\")","v":59},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113047046"}]
[null,31,"114035614","Jamie Legner","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A31)),\"\")","v":61},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113047451"}]
[null,32,"113023493","Jeanmarie Howes","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A32)),\"\")","v":62},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114025526"}]
[null,33,"113033819","Jeffrey Ronco","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A33)),\"\")","v":63},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113032048"}]
[null,34,"113029185","Jeneva Baston","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A34)),\"\")","v":66},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114043528"}]
[null,35,"112033801","Jerald Bennage","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A35)),\"\")","v":68},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"115029289"}]
[null,36,"113049615","Jewell Graham","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A36)),\"\")","v":69},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113042515"}]
[null,37,"113041233","Juliann Baskins","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A37)),\"\")","v":72},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112041982"}]
[null,38,"115031049","Juliette Brettschneide","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A38)),\"\")","v":74},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"115041412"}]
[null,39,"113040397","Junko Osucha","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A39)),\"\")","v":75},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114041566"}]
[null,40,"115030224","Kali Soravilla","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A40)),\"\")","v":76},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"114022744"}]
[null,41,"112021197","Katy Harn","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A41)),\"\")","v":77},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"115023138"}]
[null,42,"114025755","Kristan Stockley","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A42)),\"\")","v":78},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"112026305"}]
[null,43,"112044738","Krystin Nystrom","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A43)),\"\")","v":79},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113043867"}]
[null,44,"114029419","Lance Thomer","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A44)),\"\")","v":80},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":"113029291"}]
[null,45,"112024012","Lashay Rodefer","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A45)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,46,"114022488","Laurena Dejoseph","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A46)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,47,"112048864","Leana Bunker","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A47)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,48,"113040205","Leonard Tchakian","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A48)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,49,"115036986","Louetta Lannom","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A49)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,50,"115038500","Luis Dupont","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A50)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,51,"114041358","Madeleine Bradsher","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A51)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,52,"112047220","Marguerita Naillon","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A52)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,53,"114027099","Marguerite Mclachlan","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A53)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,54,"115038203","Maritza Malek","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A54)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,55,"112049764","Mauricio Niesen","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A55)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,56,"112048599","Megan Digrande","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A56)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,57,"112048545","Mellisa Sobel","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A57)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,58,"114033521","Merideth Camaron","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A58)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,59,"113047046","Mikaela Smolder","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A59)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,60,"112048983","Monnie Halcon","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A60)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,61,"113047451","Mui Leimberger","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A61)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,62,"114025526","Natalya Tuggle","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A62)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,63,"113032048","Nathan Aucoin","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A63)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,64,"114037092","Oleta Szala","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A64)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,65,"114030711","Palmira Bodie","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A65)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,66,"114043528","Rosie Wakely","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A66)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,67,"114029149","Roxy Enoch","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A67)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,68,"115029289","Shamika Levenson","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A68)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,69,"113042515","Shane Merrifield","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A69)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,70,"113024174","Sherlene Ramon","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A70)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,71,"113035644","Sueann Zerring","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A71)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,72,"112041982","Susannah Dusik","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A72)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,73,115027041,"Taryn Hasty","FAIL",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A73)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,74,"115041412","Tenisha Purdin","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A74)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,75,"114041566","Truman Bernucho","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A75)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,76,"114022744","Vada Bocci","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A76)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,77,"115023138","Veronika Bassolino","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A77)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,78,"112026305","Vicenta Lowman","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A78)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,79,"113043867","Yahaira Norris","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A79)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]
[null,80,"113029291","Yessenia Valer","PASS",{"$f":"IFERROR(_xlfn.AGGREGATE(15,3,db.Contoh[IDX],ROW(A80)),\"\")","v":""},{"$f":"IF(ISNUMBER(db.Contoh[[#This Row],[HLP.IDX]]),INDEX(db.Contoh[ID],db.Contoh[[#This Row],[HLP.IDX]]),\"\")","v":""}]

{"sheet":"CONTOH VBA","index":2,"n_rows":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"DAFTAR ID TERFILTER",112029420,null,{"$f":"SUBTOTAL(3,db.Sample[ID])","v":27}]
[]
[]
[null,"IDX","ID","NAMA","STATUS"]
[null,1,"112029420","Adelaide Conary","PROCESS"]
[null,2,"114035180","Alyson Stakoe","SUCCESS"]
[null,3,"115023769","Amiee Rabb","SUCCESS"]
[null,4,"112047853","Ann Hoeschen","PROCESS"]
[null,5,"114033924","Aron Fyler","SUCCESS"]
[null,6,"113029988","Azalee Gokey","PROCESS"]
[null,7,"114022106","Benito Conger","PROCESS"]
[null,8,"113021301","Billie Kaler","FAILED"]
[null,9,"114043545","Buddy Tavano","SUCCESS"]
[null,10,"115047224","Carmina Archey","PROCESS"]
[null,11,"115029643","Chan Demario","PROCESS"]
[null,12,"113037446","Charla Charvet","SUCCESS"]
[null,13,"115022389","Cherri Hortillosa","PROCESS"]
[null,14,"112043266","Claudette Carraher","PROCESS"]
[null,15,"113042398","Cletus Kapper","SUCCESS"]
[null,16,"113034590","Corina Arollo","PROCESS"]
[null,17,"113028118","Curtis Weglarz","FAILED"]
[null,18,"114037341","Cyrstal Stange","FAILED"]
[null,19,"113024180","David Tardy","PROCESS"]
[null,20,"114044394","Denisha Bulland","SUCCESS"]
[null,21,"113048806","Eloisa Mcgillivray","FAILED"]
[null,22,"113039298","Emmie Donald","FAILED"]
[null,23,"112045949","Enoch Arrollo","SUCCESS"]
[null,24,"114025058","Ferne Kerth","PROCESS"]
[null,25,"113045592","Garland Splatt","FAILED"]
[null,26,"113048733","Gloria Holyfield","SUCCESS"]
[null,27,"115049967","Gordon Rutten","PROCESS"]
[null,28,"113025955","Graig Kirksey","SUCCESS"]
[null,29,"113041902","Isidra Danes","SUCCESS"]
[null,30,"115031866","Jacinta Minrod","SUCCESS"]
[null,31,"114035614","Jamie Legner","SUCCESS"]
[null,32,"113023493","Jeanmarie Howes","PROCESS"]
[null,33,"113033819","Jeffrey Ronco","PROCESS"]
[null,34,"113029185","Jeneva Baston","SUCCESS"]
[null,35,"112033801","Jerald Bennage","FAILED"]
[null,36,"113049615","Jewell Graham","SUCCESS"]
[null,37,"113041233","Juliann Baskins","FAILED"]
[null,38,"115031049","Juliette Brettschneide","FAILED"]
[null,39,"113040397","Junko Osucha","FAILED"]
[null,40,"115030224","Kali Soravilla","FAILED"]
[null,41,"112021197","Katy Harn","SUCCESS"]
[null,42,"114025755","Kristan Stockley","PROCESS"]
[null,43,"112044738","Krystin Nystrom","PROCESS"]
[null,44,"114029419","Lance Thomer","SUCCESS"]
[null,45,"112024012","Lashay Rodefer","FAILED"]
[null,46,"114022488","Laurena Dejoseph","PROCESS"]
[null,47,"112048864","Leana Bunker","SUCCESS"]
[null,48,"113040205","Leonard Tchakian","FAILED"]
[null,49,"115036986","Louetta Lannom","SUCCESS"]
[null,50,"115038500","Luis Dupont","PROCESS"]
[null,51,"114041358","Madeleine Bradsher","SUCCESS"]
[null,52,"112047220","Marguerita Naillon","SUCCESS"]
[null,53,"114027099","Marguerite Mclachlan","SUCCESS"]
[null,54,"115038203","Maritza Malek","SUCCESS"]
[null,55,"112049764","Mauricio Niesen","SUCCESS"]
[null,56,"112048599","Megan Digrande","SUCCESS"]
[null,57,"112048545","Mellisa Sobel","FAILED"]
[null,58,"114033521","Merideth Camaron","FAILED"]
[null,59,"113047046","Mikaela Smolder","SUCCESS"]
[null,60,"112048983","Monnie Halcon","PROCESS"]
[null,61,"113047451","Mui Leimberger","SUCCESS"]
[null,62,"114025526","Natalya Tuggle","FAILED"]
[null,63,"113032048","Nathan Aucoin","PROCESS"]
[null,64,"114037092","Oleta Szala","PROCESS"]
[null,65,"114030711","Palmira Bodie","SUCCESS"]
[null,66,"114043528","Rosie Wakely","SUCCESS"]
[null,67,"114029149","Roxy Enoch","SUCCESS"]
[null,68,"115029289","Shamika Levenson","PROCESS"]
[null,69,"113042515","Shane Merrifield","FAILED"]
[null,70,"113024174","Sherlene Ramon","PROCESS"]
[null,71,"113035644","Sueann Zerring","PROCESS"]
[null,72,"112041982","Susannah Dusik","PROCESS"]
[null,73,115027041,"Taryn Hasty","SUCCESS"]
[null,74,"115041412","Tenisha Purdin","SUCCESS"]
[null,75,"114041566","Truman Bernucho","FAILED"]
[null,76,"114022744","Vada Bocci","PROCESS"]
[null,77,"115023138","Veronika Bassolino","FAILED"]
[null,78,"112026305","Vicenta Lowman","PROCESS"]
[null,79,"113043867","Yahaira Norris","FAILED"]
[null,80,"113029291","Yessenia Valer","FAILED"]